Quản lý website giới thiệu và bán điện thoại di động ASP.net
19.294 lượt xem;
- index.aspx.cs
- project /
1 using System;
2 using System.Data;
3 using System.Configuration;
4 using System.Collections;
5 using System.Web;
6 using System.Web.Security;
7 using System.Web.UI;
8 using System.Web.UI.WebControls;
9 using System.Web.UI.WebControls.WebParts;
10 using System.Web.UI.HtmlControls;
11 using System.Data.OleDb;
12 using SiteUtils;
13
14 public partial class sanpham : System.Web.UI.Page
15 {
16 GioHangData gh;
17 protected void Page_Load(object sender, EventArgs e)
18 {
19 ado.ketNoi();
20 string query = "Select*,'chitiet.aspx?tensp='+tensp as chitiet from tblsanpham s,tblhang h where s.mahang=h.mahang ";
21 OleDbDataAdapter adapter = new OleDbDataAdapter(query, ado.con);
22 DataSet dataset = new DataSet();
23 adapter.Fill(dataset);
24 clp1.PageSize = 12;
25 clp1.DataSource = dataset.Tables[0].DefaultView;
26 clp1.BindToControl = DataList2;
27 DataList2.DataSource = clp1.DataSourcePaged;
28 }
29 protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
30 {
31
32 }
33 protected void Button1_Click(object sender, EventArgs e)
34 {
35
36 }
37 protected void DataList1_SelectedIndexChanged(object sender, EventArgs e)
38 {
39
40 }
41 protected void DataList2_SelectedIndexChanged(object sender, EventArgs e)
42 {
43 ado.ketNoi();
44 Label lbg = (Label)DataList2.Items[DataList2.SelectedIndex].FindControl("Label10");
45 HyperLink hy = (HyperLink)DataList2.Items[DataList2.SelectedIndex].FindControl("HyperLink1");
46
47
48 lbg.Visible = true;
49 gh = new GioHangData();
50 DataTable tb;
51 if (Session["GioHang"] == null)
52 tb = gh.setTable();
53 else
54 tb = (DataTable)Session["GioHang"];
55 string query = "select * from tblSanPham where masp='" + hy.Text + "'";
56
57 OleDbDataAdapter da = new OleDbDataAdapter(query, ado.con);
58 DataTable dt = new DataTable();
59 da.Fill(dt);
60 foreach (DataRow dr in dt.Rows)
61 {
62 tb = gh.dienVaoBang(tb, dr[10].ToString(), dr["TenSP"].ToString(), 1, Convert.ToDouble(dr["Gia"]), dr["masp"].ToString());
63 Session["GioHang"] = tb;
64
65 }
66 }
67 }
2 using System.Data;
3 using System.Configuration;
4 using System.Collections;
5 using System.Web;
6 using System.Web.Security;
7 using System.Web.UI;
8 using System.Web.UI.WebControls;
9 using System.Web.UI.WebControls.WebParts;
10 using System.Web.UI.HtmlControls;
11 using System.Data.OleDb;
12 using SiteUtils;
13
14 public partial class sanpham : System.Web.UI.Page
15 {
16 GioHangData gh;
17 protected void Page_Load(object sender, EventArgs e)
18 {
19 ado.ketNoi();
20 string query = "Select*,'chitiet.aspx?tensp='+tensp as chitiet from tblsanpham s,tblhang h where s.mahang=h.mahang ";
21 OleDbDataAdapter adapter = new OleDbDataAdapter(query, ado.con);
22 DataSet dataset = new DataSet();
23 adapter.Fill(dataset);
24 clp1.PageSize = 12;
25 clp1.DataSource = dataset.Tables[0].DefaultView;
26 clp1.BindToControl = DataList2;
27 DataList2.DataSource = clp1.DataSourcePaged;
28 }
29 protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
30 {
31
32 }
33 protected void Button1_Click(object sender, EventArgs e)
34 {
35
36 }
37 protected void DataList1_SelectedIndexChanged(object sender, EventArgs e)
38 {
39
40 }
41 protected void DataList2_SelectedIndexChanged(object sender, EventArgs e)
42 {
43 ado.ketNoi();
44 Label lbg = (Label)DataList2.Items[DataList2.SelectedIndex].FindControl("Label10");
45 HyperLink hy = (HyperLink)DataList2.Items[DataList2.SelectedIndex].FindControl("HyperLink1");
46
47
48 lbg.Visible = true;
49 gh = new GioHangData();
50 DataTable tb;
51 if (Session["GioHang"] == null)
52 tb = gh.setTable();
53 else
54 tb = (DataTable)Session["GioHang"];
55 string query = "select * from tblSanPham where masp='" + hy.Text + "'";
56
57 OleDbDataAdapter da = new OleDbDataAdapter(query, ado.con);
58 DataTable dt = new DataTable();
59 da.Fill(dt);
60 foreach (DataRow dr in dt.Rows)
61 {
62 tb = gh.dienVaoBang(tb, dr[10].ToString(), dr["TenSP"].ToString(), 1, Convert.ToDouble(dr["Gia"]), dr["masp"].ToString());
63 Session["GioHang"] = tb;
64
65 }
66 }
67 }